Why is my account reconciliation still “out” even though every transaction for the period has been ticked off?

KB580.htm

Overview

If a period on your account reconciliation tallies completely with your bank statement but your expected closing bank balance is still not matching the statement, it means that a previous period no longer reconciles.

Because this may not be the period immediately prior, you will need to identify the most recent period where your account reconciliation is balanced – your starting point.

You will then need to move forward through your periods, beginning with your starting point, and reconcile any unreconciled transactions.

Finding a starting point where the account is reconciled

There are two methods you can use to identify a starting point. You can either use SA2338 - Account reconciliation report, or use the Account Reconciliation form.

Using SA2338 – Account reconciliation report

  1. Launch the report by pressing CTRL+SHIFT+R and typing SA2338.
  2. Enter the Account code and current period dates.
  3. Check if your Expected closing bank balance equals your Closing account balance in G/L.
  4. If these balances aren’t equal, change the start and end dates to the start and end dates of the previous period and compare those balances.
  5. Repeat this process until you find a period where these values are equal – this is your starting point.

Using the Account reconciliation form

  1. From the toolbar, launch the Account Reconciliation form (General ledger > Account reconciliation…).
  2. Enter the Account code, current Month/Range, and the Closing balance/Opening balance.
  3. Check if the Out of balance amount is $0.00.
  4. If this amount isn’t $0.00, change the Month/Range and Closing balance/Opening balance to the corresponding values from the previous period and check the new Out of balance amount.
  5. Repeat this process until you find a period where the Out of balance amount is $0.00.

Reconciling your transactions

Now that you have identified your starting period, you know that any unreconciled transactions must appear after this point. Move forward through the transactions period-by-period and reconcile your unreconciled transactions.

Did you find this article helpful?

If this article is missing information, ambiguous or didn’t give you clear instructions, let us know and we will make it better! Please email us and quote the KB# in the top left of this article to let us know why it didn’t help you out and we will point you in the direction of additional information.

Last edit: 12/05/2026